Released on: October 8, 2008, 5:15 pm

Press Release Author: Alba Spectrum LLC

Industry: Computers

Press Release Summary: If you have implemented SAP B1 and now have phase two
integration with legacy system or external CRM application needs, then you should
first research SAP Business One Data Transfer Workbench and its ODBC integration
options. This publication should ideally help you with your SAP Business One
consultant, VAR or technology partner selection.

Press Release Body: If you have implemented SAP B1 and now have phase two
integration with legacy system or external CRM application needs, then you should
first research SAP Business One Data Transfer Workbench and its ODBC integration
options. This publication should ideally help you with your SAP Business One
consultant, VAR or technology partner selection. If you need advanced integrating
application with custom screens, you should consider developing in C# or VB.Net with
SAP Business One SDK gateway to your SB1 server. Let's come to technology
highlights:

1. SB1 Workbench. You probably heard from SAP Business One consultants the
convenient way to move your legacy ERP application objects to SAP Business One. All
you need to do is to fill our Excel CSV templates and they will be integrated via
Workbench. However this is not the whole story - in fact, Workbench could serve you
as ongoing integration tool, where you schedule integrations in DOS Batch file by
calling Workbench with the parameter of saved integration setup CML file

2. SQL Views. If you want to prepare your records for integration automatically,
consider switching from Excel CSV templates to ODBC integration in Workbench, where
ODBC connects to SQL complain database with prepared SQL view - it could be Oracle,
MS SQL Server, Pervasive SQL, Microsoft Access to give you flexibility idea

3. SB1 tables structure. In SDK you can research the structure, however when you
need to prepare your Workbench integration, the best idea is to look up relevant
tables and their contents in SB1 MS SQL Server company database. In SB1
View->System Information - this will give you table, form and field info in left
lower corner. Try this - open Inventory->Item Master Data and place the cursor over
the field to the right of the Item Number - you should see the table name is OITM
and the field name is ItemCode. Please continue your discovery, if you need help,
let us know


Web Site: http://www.albaspectrum.com

Contact Details: Andrew Karasev, Alba Spectrum LLC, help@albaspectrum.com,
http://www.albaspectrum.com, 1-866-528-0577 , subdivision of M2-D2, SAP Business
One VAR and Reseller in Illinois, Georgia, South Carolina, California, Texas. Please
visit our info portal Pegas Planet: http://www.pegasplanet.com. Local Service in
Chicago, Atlanta, San Diego, Los Angeles, Orange County, Houston. We also have SAP
Business One Software Development Factory and SB1 Technical Support Call Center,
serving USA country side businesses and internationally: Canada, Brazil. Illinois
practice: Naperville, Aurora, Plainfield, Marseilles, Ottawa, DeKalb, Springfield,
Oakbrook, Glenn Ellyn, Wheaton, Bolingbrook, Romeoville, Lisle, Melrose Park,
Brookfield. San Diego and LA practice: Rancho Bernardo, Oceanside, Poway, Long
Beach, Irvine, Mission Viejo, San Marcos, Carlsbad, La Jolla, Escondido. Houston
Practice: Dallas, Galveston, Sugar Land, Pearland, Katy, Pasadena, Rosenberg, League
City, Galena Park